Company DescriptionE*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website www.epro-tech.com.Job DescriptionWe are currently hiring for BI Solution Architect Fulltime position with our client. #########NO THIRD PARTY SUBCONTRACTING for these positions#########Job Title : BI Solution ArchitectLocation : Farmingham,MAJob Type : Permanent Full TimeUS Citizen/ Green Card Holder/EAD (GC) can apply for this Job Required Skills:• 9 years of experience in the field of Data modeling and Data Architecture Teradata based physical database design leveraging constructs such as Secondary/Join indexes, Statistics, Partitioned Primary Indexes.• Design and develop load processes using BETEQ scripts & Teradata based load utilities (TPT, Fastload/Multiload) and queries with complex workloads and large transaction volumes.• Expertise in ELT based data transformation to apply complex business rules to transform source data. • Identification and optimization of sub-optimal queries & load processes. • Adoption of features/best practices introduced in newer versions of Teradata. • Assist ETL & BI development teams in writing complex SQL in an efficient way leveraging Teradata best practices. • Ability to understand data and develop Subject matter expertise on complex applications. • Review logical and physical data models to support complex end user dashboard/reports and queries.• Ability to drive and lead projects during the implementation, test and deploy phases proactively identify & mitigating technical issues. Ability to work in a matrix environment consisting of Solution, Business Intelligence, Data Integration & Quality Assurance teams and successfully collaborate to meet the project objectives • Developing and implementing Enterprise Data Warehousing (EDW), Data Warehouses (DW), Data Marts (DM), Decision Support Systems (DSS) and Operational Data Stores (ODS) etc..• Developing and maintaining enterprise-wide data models, Logical Data Models (LDM), Physical Data Models (PDM)• Excellent personal communication, leadership, and organizational skills • Retail related data warehousing experience a plus• Excellent personal communication, leadership, and organizational skills • Retail related data warehousing experience a plus If you are interested, kindly respond with your updated word format resume with the following details.Work Status: Best #:Best Time to reach:Expected Salary:Availability to join: Note: I choose to contact you either because your resume had been posted to one of the internet job sites, or you had previously submitted your resumes to E*Pro. I assumed that you are either looking for a new employment opportunity, or you are interested in investigating the current job market. Thanks & Best regards,Chandra kumarE*Pro, Inc.,Ph: 732-283-0499 X 272www.eprocorp.com If you are not currently seeking employment, or if you would prefer I contact you at some later date, please indicate your date of availability so that I comply with your request. In any event, I respectfully recommend you continue to avail yourself to the employment options and job market information we provide with our e-mail notices. Additional InformationAll your information will be kept confidential according to EEO guidelines.Duration: 9 monthsInterviews: 3/182015Start Date: 3/31/2015Rate : 50-60/hr on W2 - All Inclusive(Depending on experinece)